SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.[DnnProduct_GetAllFiles]
AS
BEGIN
	SELECT
		F.FileId,
		FO.PortalId,
		F.[FileName],
		F.Extension,
		F.Size,
		F.Width,
		F.Height,
		F.ContentType,
		F.FolderID,
		'Folder' = FolderPath,
		FO.StorageLocation,
		FO.IsCached,
		F.UniqueId,
		F.VersionGuid,
		F.SHA1Hash,
		FO.FolderMappingID
	FROM dbo.[DnnProduct_Files] F
	INNER JOIN dbo.[DnnProduct_Folders] FO on F.FolderID = FO.FolderID
END
GO
